package com.zkzx.company.base.mapper.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CompanyExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public CompanyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public CompanyExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public CompanyExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public CompanyExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("cid is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("cid is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(String value) {
            addCriterion("cid =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(String value) {
            addCriterion("cid <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(String value) {
            addCriterion("cid >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(String value) {
            addCriterion("cid >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(String value) {
            addCriterion("cid <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(String value) {
            addCriterion("cid <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLike(String value) {
            addCriterion("cid like", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotLike(String value) {
            addCriterion("cid not like", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<String> values) {
            addCriterion("cid in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<String> values) {
            addCriterion("cid not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(String value1, String value2) {
            addCriterion("cid between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(String value1, String value2) {
            addCriterion("cid not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("code <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("code >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("code <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("code not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("code in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("code not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("code between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("code not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andThreeidIsNull() {
            addCriterion("threeId is null");
            return (Criteria) this;
        }

        public Criteria andThreeidIsNotNull() {
            addCriterion("threeId is not null");
            return (Criteria) this;
        }

        public Criteria andThreeidEqualTo(String value) {
            addCriterion("threeId =", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidNotEqualTo(String value) {
            addCriterion("threeId <>", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidGreaterThan(String value) {
            addCriterion("threeId >", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidGreaterThanOrEqualTo(String value) {
            addCriterion("threeId >=", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidLessThan(String value) {
            addCriterion("threeId <", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidLessThanOrEqualTo(String value) {
            addCriterion("threeId <=", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidLike(String value) {
            addCriterion("threeId like", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidNotLike(String value) {
            addCriterion("threeId not like", value, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidIn(List<String> values) {
            addCriterion("threeId in", values, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidNotIn(List<String> values) {
            addCriterion("threeId not in", values, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidBetween(String value1, String value2) {
            addCriterion("threeId between", value1, value2, "threeid");
            return (Criteria) this;
        }

        public Criteria andThreeidNotBetween(String value1, String value2) {
            addCriterion("threeId not between", value1, value2, "threeid");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(String value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(String value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(String value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(String value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(String value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(String value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLike(String value) {
            addCriterion("type like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotLike(String value) {
            addCriterion("type not like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<String> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<String> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(String value1, String value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(String value1, String value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andPersonIsNull() {
            addCriterion("person is null");
            return (Criteria) this;
        }

        public Criteria andPersonIsNotNull() {
            addCriterion("person is not null");
            return (Criteria) this;
        }

        public Criteria andPersonEqualTo(String value) {
            addCriterion("person =", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotEqualTo(String value) {
            addCriterion("person <>", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonGreaterThan(String value) {
            addCriterion("person >", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonGreaterThanOrEqualTo(String value) {
            addCriterion("person >=", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonLessThan(String value) {
            addCriterion("person <", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonLessThanOrEqualTo(String value) {
            addCriterion("person <=", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonLike(String value) {
            addCriterion("person like", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotLike(String value) {
            addCriterion("person not like", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonIn(List<String> values) {
            addCriterion("person in", values, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotIn(List<String> values) {
            addCriterion("person not in", values, "person");
            return (Criteria) this;
        }

        public Criteria andPersonBetween(String value1, String value2) {
            addCriterion("person between", value1, value2, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotBetween(String value1, String value2) {
            addCriterion("person not between", value1, value2, "person");
            return (Criteria) this;
        }

        public Criteria andRegaddressIsNull() {
            addCriterion("regAddress is null");
            return (Criteria) this;
        }

        public Criteria andRegaddressIsNotNull() {
            addCriterion("regAddress is not null");
            return (Criteria) this;
        }

        public Criteria andRegaddressEqualTo(String value) {
            addCriterion("regAddress =", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressNotEqualTo(String value) {
            addCriterion("regAddress <>", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressGreaterThan(String value) {
            addCriterion("regAddress >", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressGreaterThanOrEqualTo(String value) {
            addCriterion("regAddress >=", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressLessThan(String value) {
            addCriterion("regAddress <", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressLessThanOrEqualTo(String value) {
            addCriterion("regAddress <=", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressLike(String value) {
            addCriterion("regAddress like", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressNotLike(String value) {
            addCriterion("regAddress not like", value, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressIn(List<String> values) {
            addCriterion("regAddress in", values, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressNotIn(List<String> values) {
            addCriterion("regAddress not in", values, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressBetween(String value1, String value2) {
            addCriterion("regAddress between", value1, value2, "regaddress");
            return (Criteria) this;
        }

        public Criteria andRegaddressNotBetween(String value1, String value2) {
            addCriterion("regAddress not between", value1, value2, "regaddress");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCountyIsNull() {
            addCriterion("county is null");
            return (Criteria) this;
        }

        public Criteria andCountyIsNotNull() {
            addCriterion("county is not null");
            return (Criteria) this;
        }

        public Criteria andCountyEqualTo(String value) {
            addCriterion("county =", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotEqualTo(String value) {
            addCriterion("county <>", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThan(String value) {
            addCriterion("county >", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThanOrEqualTo(String value) {
            addCriterion("county >=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThan(String value) {
            addCriterion("county <", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThanOrEqualTo(String value) {
            addCriterion("county <=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLike(String value) {
            addCriterion("county like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotLike(String value) {
            addCriterion("county not like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyIn(List<String> values) {
            addCriterion("county in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotIn(List<String> values) {
            addCriterion("county not in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyBetween(String value1, String value2) {
            addCriterion("county between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotBetween(String value1, String value2) {
            addCriterion("county not between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andRegtimeIsNull() {
            addCriterion("regTime is null");
            return (Criteria) this;
        }

        public Criteria andRegtimeIsNotNull() {
            addCriterion("regTime is not null");
            return (Criteria) this;
        }

        public Criteria andRegtimeEqualTo(String value) {
            addCriterion("regTime =", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeNotEqualTo(String value) {
            addCriterion("regTime <>", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeGreaterThan(String value) {
            addCriterion("regTime >", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeGreaterThanOrEqualTo(String value) {
            addCriterion("regTime >=", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeLessThan(String value) {
            addCriterion("regTime <", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeLessThanOrEqualTo(String value) {
            addCriterion("regTime <=", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeLike(String value) {
            addCriterion("regTime like", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeNotLike(String value) {
            addCriterion("regTime not like", value, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeIn(List<String> values) {
            addCriterion("regTime in", values, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeNotIn(List<String> values) {
            addCriterion("regTime not in", values, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeBetween(String value1, String value2) {
            addCriterion("regTime between", value1, value2, "regtime");
            return (Criteria) this;
        }

        public Criteria andRegtimeNotBetween(String value1, String value2) {
            addCriterion("regTime not between", value1, value2, "regtime");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesIsNull() {
            addCriterion("taxAuthorities is null");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesIsNotNull() {
            addCriterion("taxAuthorities is not null");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesEqualTo(String value) {
            addCriterion("taxAuthorities =", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesNotEqualTo(String value) {
            addCriterion("taxAuthorities <>", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesGreaterThan(String value) {
            addCriterion("taxAuthorities >", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesGreaterThanOrEqualTo(String value) {
            addCriterion("taxAuthorities >=", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesLessThan(String value) {
            addCriterion("taxAuthorities <", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesLessThanOrEqualTo(String value) {
            addCriterion("taxAuthorities <=", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesLike(String value) {
            addCriterion("taxAuthorities like", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesNotLike(String value) {
            addCriterion("taxAuthorities not like", value, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesIn(List<String> values) {
            addCriterion("taxAuthorities in", values, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesNotIn(List<String> values) {
            addCriterion("taxAuthorities not in", values, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesBetween(String value1, String value2) {
            addCriterion("taxAuthorities between", value1, value2, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andTaxauthoritiesNotBetween(String value1, String value2) {
            addCriterion("taxAuthorities not between", value1, value2, "taxauthorities");
            return (Criteria) this;
        }

        public Criteria andRegamountIsNull() {
            addCriterion("regAmount is null");
            return (Criteria) this;
        }

        public Criteria andRegamountIsNotNull() {
            addCriterion("regAmount is not null");
            return (Criteria) this;
        }

        public Criteria andRegamountEqualTo(String value) {
            addCriterion("regAmount =", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountNotEqualTo(String value) {
            addCriterion("regAmount <>", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountGreaterThan(String value) {
            addCriterion("regAmount >", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountGreaterThanOrEqualTo(String value) {
            addCriterion("regAmount >=", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountLessThan(String value) {
            addCriterion("regAmount <", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountLessThanOrEqualTo(String value) {
            addCriterion("regAmount <=", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountLike(String value) {
            addCriterion("regAmount like", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountNotLike(String value) {
            addCriterion("regAmount not like", value, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountIn(List<String> values) {
            addCriterion("regAmount in", values, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountNotIn(List<String> values) {
            addCriterion("regAmount not in", values, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountBetween(String value1, String value2) {
            addCriterion("regAmount between", value1, value2, "regamount");
            return (Criteria) this;
        }

        public Criteria andRegamountNotBetween(String value1, String value2) {
            addCriterion("regAmount not between", value1, value2, "regamount");
            return (Criteria) this;
        }

        public Criteria andFoundtimeIsNull() {
            addCriterion("foundTime is null");
            return (Criteria) this;
        }

        public Criteria andFoundtimeIsNotNull() {
            addCriterion("foundTime is not null");
            return (Criteria) this;
        }

        public Criteria andFoundtimeEqualTo(String value) {
            addCriterion("foundTime =", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeNotEqualTo(String value) {
            addCriterion("foundTime <>", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeGreaterThan(String value) {
            addCriterion("foundTime >", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeGreaterThanOrEqualTo(String value) {
            addCriterion("foundTime >=", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeLessThan(String value) {
            addCriterion("foundTime <", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeLessThanOrEqualTo(String value) {
            addCriterion("foundTime <=", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeLike(String value) {
            addCriterion("foundTime like", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeNotLike(String value) {
            addCriterion("foundTime not like", value, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeIn(List<String> values) {
            addCriterion("foundTime in", values, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeNotIn(List<String> values) {
            addCriterion("foundTime not in", values, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeBetween(String value1, String value2) {
            addCriterion("foundTime between", value1, value2, "foundtime");
            return (Criteria) this;
        }

        public Criteria andFoundtimeNotBetween(String value1, String value2) {
            addCriterion("foundTime not between", value1, value2, "foundtime");
            return (Criteria) this;
        }

        public Criteria andScopeIsNull() {
            addCriterion("scope is null");
            return (Criteria) this;
        }

        public Criteria andScopeIsNotNull() {
            addCriterion("scope is not null");
            return (Criteria) this;
        }

        public Criteria andScopeEqualTo(String value) {
            addCriterion("scope =", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeNotEqualTo(String value) {
            addCriterion("scope <>", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeGreaterThan(String value) {
            addCriterion("scope >", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeGreaterThanOrEqualTo(String value) {
            addCriterion("scope >=", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeLessThan(String value) {
            addCriterion("scope <", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeLessThanOrEqualTo(String value) {
            addCriterion("scope <=", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeLike(String value) {
            addCriterion("scope like", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeNotLike(String value) {
            addCriterion("scope not like", value, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeIn(List<String> values) {
            addCriterion("scope in", values, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeNotIn(List<String> values) {
            addCriterion("scope not in", values, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeBetween(String value1, String value2) {
            addCriterion("scope between", value1, value2, "scope");
            return (Criteria) this;
        }

        public Criteria andScopeNotBetween(String value1, String value2) {
            addCriterion("scope not between", value1, value2, "scope");
            return (Criteria) this;
        }

        public Criteria andBusinesspicIsNull() {
            addCriterion("businessPic is null");
            return (Criteria) this;
        }

        public Criteria andBusinesspicIsNotNull() {
            addCriterion("businessPic is not null");
            return (Criteria) this;
        }

        public Criteria andBusinesspicEqualTo(String value) {
            addCriterion("businessPic =", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicNotEqualTo(String value) {
            addCriterion("businessPic <>", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicGreaterThan(String value) {
            addCriterion("businessPic >", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicGreaterThanOrEqualTo(String value) {
            addCriterion("businessPic >=", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicLessThan(String value) {
            addCriterion("businessPic <", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicLessThanOrEqualTo(String value) {
            addCriterion("businessPic <=", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicLike(String value) {
            addCriterion("businessPic like", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicNotLike(String value) {
            addCriterion("businessPic not like", value, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicIn(List<String> values) {
            addCriterion("businessPic in", values, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicNotIn(List<String> values) {
            addCriterion("businessPic not in", values, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicBetween(String value1, String value2) {
            addCriterion("businessPic between", value1, value2, "businesspic");
            return (Criteria) this;
        }

        public Criteria andBusinesspicNotBetween(String value1, String value2) {
            addCriterion("businessPic not between", value1, value2, "businesspic");
            return (Criteria) this;
        }

        public Criteria andLicensepicIsNull() {
            addCriterion("licensePic is null");
            return (Criteria) this;
        }

        public Criteria andLicensepicIsNotNull() {
            addCriterion("licensePic is not null");
            return (Criteria) this;
        }

        public Criteria andLicensepicEqualTo(String value) {
            addCriterion("licensePic =", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicNotEqualTo(String value) {
            addCriterion("licensePic <>", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicGreaterThan(String value) {
            addCriterion("licensePic >", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicGreaterThanOrEqualTo(String value) {
            addCriterion("licensePic >=", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicLessThan(String value) {
            addCriterion("licensePic <", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicLessThanOrEqualTo(String value) {
            addCriterion("licensePic <=", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicLike(String value) {
            addCriterion("licensePic like", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicNotLike(String value) {
            addCriterion("licensePic not like", value, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicIn(List<String> values) {
            addCriterion("licensePic in", values, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicNotIn(List<String> values) {
            addCriterion("licensePic not in", values, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicBetween(String value1, String value2) {
            addCriterion("licensePic between", value1, value2, "licensepic");
            return (Criteria) this;
        }

        public Criteria andLicensepicNotBetween(String value1, String value2) {
            addCriterion("licensePic not between", value1, value2, "licensepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicIsNull() {
            addCriterion("authorizePic is null");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicIsNotNull() {
            addCriterion("authorizePic is not null");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicEqualTo(String value) {
            addCriterion("authorizePic =", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicNotEqualTo(String value) {
            addCriterion("authorizePic <>", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicGreaterThan(String value) {
            addCriterion("authorizePic >", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicGreaterThanOrEqualTo(String value) {
            addCriterion("authorizePic >=", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicLessThan(String value) {
            addCriterion("authorizePic <", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicLessThanOrEqualTo(String value) {
            addCriterion("authorizePic <=", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicLike(String value) {
            addCriterion("authorizePic like", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicNotLike(String value) {
            addCriterion("authorizePic not like", value, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicIn(List<String> values) {
            addCriterion("authorizePic in", values, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicNotIn(List<String> values) {
            addCriterion("authorizePic not in", values, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicBetween(String value1, String value2) {
            addCriterion("authorizePic between", value1, value2, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andAuthorizepicNotBetween(String value1, String value2) {
            addCriterion("authorizePic not between", value1, value2, "authorizepic");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andContractcodeIsNull() {
            addCriterion("contractCode is null");
            return (Criteria) this;
        }

        public Criteria andContractcodeIsNotNull() {
            addCriterion("contractCode is not null");
            return (Criteria) this;
        }

        public Criteria andContractcodeEqualTo(String value) {
            addCriterion("contractCode =", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeNotEqualTo(String value) {
            addCriterion("contractCode <>", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeGreaterThan(String value) {
            addCriterion("contractCode >", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeGreaterThanOrEqualTo(String value) {
            addCriterion("contractCode >=", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeLessThan(String value) {
            addCriterion("contractCode <", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeLessThanOrEqualTo(String value) {
            addCriterion("contractCode <=", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeLike(String value) {
            addCriterion("contractCode like", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeNotLike(String value) {
            addCriterion("contractCode not like", value, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeIn(List<String> values) {
            addCriterion("contractCode in", values, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeNotIn(List<String> values) {
            addCriterion("contractCode not in", values, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeBetween(String value1, String value2) {
            addCriterion("contractCode between", value1, value2, "contractcode");
            return (Criteria) this;
        }

        public Criteria andContractcodeNotBetween(String value1, String value2) {
            addCriterion("contractCode not between", value1, value2, "contractcode");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeIsNull() {
            addCriterion("contractStartTime is null");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeIsNotNull() {
            addCriterion("contractStartTime is not null");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeEqualTo(String value) {
            addCriterion("contractStartTime =", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeNotEqualTo(String value) {
            addCriterion("contractStartTime <>", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeGreaterThan(String value) {
            addCriterion("contractStartTime >", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeGreaterThanOrEqualTo(String value) {
            addCriterion("contractStartTime >=", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeLessThan(String value) {
            addCriterion("contractStartTime <", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeLessThanOrEqualTo(String value) {
            addCriterion("contractStartTime <=", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeLike(String value) {
            addCriterion("contractStartTime like", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeNotLike(String value) {
            addCriterion("contractStartTime not like", value, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeIn(List<String> values) {
            addCriterion("contractStartTime in", values, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeNotIn(List<String> values) {
            addCriterion("contractStartTime not in", values, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeBetween(String value1, String value2) {
            addCriterion("contractStartTime between", value1, value2, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractstarttimeNotBetween(String value1, String value2) {
            addCriterion("contractStartTime not between", value1, value2, "contractstarttime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeIsNull() {
            addCriterion("contractEndTime is null");
            return (Criteria) this;
        }

        public Criteria andContractendtimeIsNotNull() {
            addCriterion("contractEndTime is not null");
            return (Criteria) this;
        }

        public Criteria andContractendtimeEqualTo(String value) {
            addCriterion("contractEndTime =", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeNotEqualTo(String value) {
            addCriterion("contractEndTime <>", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeGreaterThan(String value) {
            addCriterion("contractEndTime >", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeGreaterThanOrEqualTo(String value) {
            addCriterion("contractEndTime >=", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeLessThan(String value) {
            addCriterion("contractEndTime <", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeLessThanOrEqualTo(String value) {
            addCriterion("contractEndTime <=", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeLike(String value) {
            addCriterion("contractEndTime like", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeNotLike(String value) {
            addCriterion("contractEndTime not like", value, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeIn(List<String> values) {
            addCriterion("contractEndTime in", values, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeNotIn(List<String> values) {
            addCriterion("contractEndTime not in", values, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeBetween(String value1, String value2) {
            addCriterion("contractEndTime between", value1, value2, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractendtimeNotBetween(String value1, String value2) {
            addCriterion("contractEndTime not between", value1, value2, "contractendtime");
            return (Criteria) this;
        }

        public Criteria andContractfileIsNull() {
            addCriterion("contractFile is null");
            return (Criteria) this;
        }

        public Criteria andContractfileIsNotNull() {
            addCriterion("contractFile is not null");
            return (Criteria) this;
        }

        public Criteria andContractfileEqualTo(String value) {
            addCriterion("contractFile =", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileNotEqualTo(String value) {
            addCriterion("contractFile <>", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileGreaterThan(String value) {
            addCriterion("contractFile >", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileGreaterThanOrEqualTo(String value) {
            addCriterion("contractFile >=", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileLessThan(String value) {
            addCriterion("contractFile <", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileLessThanOrEqualTo(String value) {
            addCriterion("contractFile <=", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileLike(String value) {
            addCriterion("contractFile like", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileNotLike(String value) {
            addCriterion("contractFile not like", value, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileIn(List<String> values) {
            addCriterion("contractFile in", values, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileNotIn(List<String> values) {
            addCriterion("contractFile not in", values, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileBetween(String value1, String value2) {
            addCriterion("contractFile between", value1, value2, "contractfile");
            return (Criteria) this;
        }

        public Criteria andContractfileNotBetween(String value1, String value2) {
            addCriterion("contractFile not between", value1, value2, "contractfile");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andMembercodeIsNull() {
            addCriterion("memberCode is null");
            return (Criteria) this;
        }

        public Criteria andMembercodeIsNotNull() {
            addCriterion("memberCode is not null");
            return (Criteria) this;
        }

        public Criteria andMembercodeEqualTo(String value) {
            addCriterion("memberCode =", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeNotEqualTo(String value) {
            addCriterion("memberCode <>", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeGreaterThan(String value) {
            addCriterion("memberCode >", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeGreaterThanOrEqualTo(String value) {
            addCriterion("memberCode >=", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeLessThan(String value) {
            addCriterion("memberCode <", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeLessThanOrEqualTo(String value) {
            addCriterion("memberCode <=", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeLike(String value) {
            addCriterion("memberCode like", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeNotLike(String value) {
            addCriterion("memberCode not like", value, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeIn(List<String> values) {
            addCriterion("memberCode in", values, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeNotIn(List<String> values) {
            addCriterion("memberCode not in", values, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeBetween(String value1, String value2) {
            addCriterion("memberCode between", value1, value2, "membercode");
            return (Criteria) this;
        }

        public Criteria andMembercodeNotBetween(String value1, String value2) {
            addCriterion("memberCode not between", value1, value2, "membercode");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeIsNull() {
            addCriterion("lastModifiedTime is null");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeIsNotNull() {
            addCriterion("lastModifiedTime is not null");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeEqualTo(Date value) {
            addCriterion("lastModifiedTime =", value, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeNotEqualTo(Date value) {
            addCriterion("lastModifiedTime <>", value, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeGreaterThan(Date value) {
            addCriterion("lastModifiedTime >", value, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lastModifiedTime >=", value, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeLessThan(Date value) {
            addCriterion("lastModifiedTime <", value, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeLessThanOrEqualTo(Date value) {
            addCriterion("lastModifiedTime <=", value, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeIn(List<Date> values) {
            addCriterion("lastModifiedTime in", values, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeNotIn(List<Date> values) {
            addCriterion("lastModifiedTime not in", values, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeBetween(Date value1, Date value2) {
            addCriterion("lastModifiedTime between", value1, value2, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andLastmodifiedtimeNotBetween(Date value1, Date value2) {
            addCriterion("lastModifiedTime not between", value1, value2, "lastmodifiedtime");
            return (Criteria) this;
        }

        public Criteria andCreateuserIsNull() {
            addCriterion("createUser is null");
            return (Criteria) this;
        }

        public Criteria andCreateuserIsNotNull() {
            addCriterion("createUser is not null");
            return (Criteria) this;
        }

        public Criteria andCreateuserEqualTo(Integer value) {
            addCriterion("createUser =", value, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserNotEqualTo(Integer value) {
            addCriterion("createUser <>", value, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserGreaterThan(Integer value) {
            addCriterion("createUser >", value, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserGreaterThanOrEqualTo(Integer value) {
            addCriterion("createUser >=", value, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserLessThan(Integer value) {
            addCriterion("createUser <", value, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserLessThanOrEqualTo(Integer value) {
            addCriterion("createUser <=", value, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserIn(List<Integer> values) {
            addCriterion("createUser in", values, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserNotIn(List<Integer> values) {
            addCriterion("createUser not in", values, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserBetween(Integer value1, Integer value2) {
            addCriterion("createUser between", value1, value2, "createuser");
            return (Criteria) this;
        }

        public Criteria andCreateuserNotBetween(Integer value1, Integer value2) {
            addCriterion("createUser not between", value1, value2, "createuser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserIsNull() {
            addCriterion("lastModifiedUser is null");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserIsNotNull() {
            addCriterion("lastModifiedUser is not null");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserEqualTo(Integer value) {
            addCriterion("lastModifiedUser =", value, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserNotEqualTo(Integer value) {
            addCriterion("lastModifiedUser <>", value, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserGreaterThan(Integer value) {
            addCriterion("lastModifiedUser >", value, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserGreaterThanOrEqualTo(Integer value) {
            addCriterion("lastModifiedUser >=", value, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserLessThan(Integer value) {
            addCriterion("lastModifiedUser <", value, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserLessThanOrEqualTo(Integer value) {
            addCriterion("lastModifiedUser <=", value, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserIn(List<Integer> values) {
            addCriterion("lastModifiedUser in", values, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserNotIn(List<Integer> values) {
            addCriterion("lastModifiedUser not in", values, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserBetween(Integer value1, Integer value2) {
            addCriterion("lastModifiedUser between", value1, value2, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andLastmodifieduserNotBetween(Integer value1, Integer value2) {
            addCriterion("lastModifiedUser not between", value1, value2, "lastmodifieduser");
            return (Criteria) this;
        }

        public Criteria andRegionidIsNull() {
            addCriterion("regionId is null");
            return (Criteria) this;
        }

        public Criteria andRegionidIsNotNull() {
            addCriterion("regionId is not null");
            return (Criteria) this;
        }

        public Criteria andRegionidEqualTo(String value) {
            addCriterion("regionId =", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidNotEqualTo(String value) {
            addCriterion("regionId <>", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidGreaterThan(String value) {
            addCriterion("regionId >", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidGreaterThanOrEqualTo(String value) {
            addCriterion("regionId >=", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidLessThan(String value) {
            addCriterion("regionId <", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidLessThanOrEqualTo(String value) {
            addCriterion("regionId <=", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidLike(String value) {
            addCriterion("regionId like", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidNotLike(String value) {
            addCriterion("regionId not like", value, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidIn(List<String> values) {
            addCriterion("regionId in", values, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidNotIn(List<String> values) {
            addCriterion("regionId not in", values, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidBetween(String value1, String value2) {
            addCriterion("regionId between", value1, value2, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegionidNotBetween(String value1, String value2) {
            addCriterion("regionId not between", value1, value2, "regionid");
            return (Criteria) this;
        }

        public Criteria andRegioninfoIsNull() {
            addCriterion("regionInfo is null");
            return (Criteria) this;
        }

        public Criteria andRegioninfoIsNotNull() {
            addCriterion("regionInfo is not null");
            return (Criteria) this;
        }

        public Criteria andRegioninfoEqualTo(String value) {
            addCriterion("regionInfo =", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoNotEqualTo(String value) {
            addCriterion("regionInfo <>", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoGreaterThan(String value) {
            addCriterion("regionInfo >", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoGreaterThanOrEqualTo(String value) {
            addCriterion("regionInfo >=", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoLessThan(String value) {
            addCriterion("regionInfo <", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoLessThanOrEqualTo(String value) {
            addCriterion("regionInfo <=", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoLike(String value) {
            addCriterion("regionInfo like", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoNotLike(String value) {
            addCriterion("regionInfo not like", value, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoIn(List<String> values) {
            addCriterion("regionInfo in", values, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoNotIn(List<String> values) {
            addCriterion("regionInfo not in", values, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoBetween(String value1, String value2) {
            addCriterion("regionInfo between", value1, value2, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andRegioninfoNotBetween(String value1, String value2) {
            addCriterion("regionInfo not between", value1, value2, "regioninfo");
            return (Criteria) this;
        }

        public Criteria andReasonIsNull() {
            addCriterion("reason is null");
            return (Criteria) this;
        }

        public Criteria andReasonIsNotNull() {
            addCriterion("reason is not null");
            return (Criteria) this;
        }

        public Criteria andReasonEqualTo(String value) {
            addCriterion("reason =", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotEqualTo(String value) {
            addCriterion("reason <>", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThan(String value) {
            addCriterion("reason >", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonGreaterThanOrEqualTo(String value) {
            addCriterion("reason >=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThan(String value) {
            addCriterion("reason <", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLessThanOrEqualTo(String value) {
            addCriterion("reason <=", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonLike(String value) {
            addCriterion("reason like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotLike(String value) {
            addCriterion("reason not like", value, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonIn(List<String> values) {
            addCriterion("reason in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotIn(List<String> values) {
            addCriterion("reason not in", values, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonBetween(String value1, String value2) {
            addCriterion("reason between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andReasonNotBetween(String value1, String value2) {
            addCriterion("reason not between", value1, value2, "reason");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}